SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424109 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424109 [ RunTime:0.003696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955371,140495,1017534,464976,422966,131976,36539,1048783,615105,893426,1037288,443682,1027147,332953,837239,379074,206390,1020955,142890,186631,438353,88813,418742,314815,405148,951778,352399,750922,262090,806252,927584,968196,34303,773356,961569,626522,353020,60093,348388,64742,170353,253203,729313,449448,186574,844897,209561,176220,1040512,49782,806141,259151,774625,452082,156239,1010113,971939,583687,821124,782513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]