SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534805 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534805 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207966,458660,511082,664127,171568,934703,106881,1039100,1022178,637873,466525,902175,384307,995116,185310,1037304,31496,910401,240556,844611,1007431,662414,1018406,857034,293317,908842,805249,26356,986004,158470,802180,1022847,665837,943371,799502,619875,861599,287413,481326,664770,427639,248854,838382,854135,974657,883120,392017,919611,947687,821741,89787,282762,337585,305609,893157,503385,837519,281967,844988,720140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]