SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001560s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445404 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445404 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000277,423804,871984,659092,687521,607391,537193,696193,409220,214237,689910,4555,491419,865233,12569,73926,72431,81975,369624,738424,464618,662694,867965,220538,536626,577329,505557,563744,60418,769636,871622,522976,924958,771545,619667,214101,60132,1047082,1043937,30263,245533,49660,149232,556656,295181,636985,1016494,393915,949812,1044716,652914,743745,1043506,660736,678655,719255,121370,42168,11392,540052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000901s ]