SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467307 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467307 [ RunTime:0.004231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305246,103154,168681,26283,382296,7860,761730,407003,615654,488426,718906,1009851,410026,236266,251309,521588,238533,134672,323093,642963,920990,538775,397787,221283,280053,171293,775248,1038874,752979,812722,751166,783522,334569,285420,653543,720120,376396,986410,170614,992799,267009,490930,852261,398555,589571,504807,1036624,283025,599008,164049,22374,613009,237479,693824,467684,561646,954001,557826,8128,879848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]