SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53578 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53578 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102988,137726,331548,34883,175761,932334,498974,214899,601973,677838,111944,881798,211153,484796,765553,178461,121767,897182,352018,82521,26906,921949,643681,12152,124874,131453,136992,869704,1006550,929103,976250,682429,566721,816084,521215,378568,993368,133755,59071,102989,678152,747444,481726,853153,832504,881314,747055,539230,452915,81704,190204,204347,284552,151950,860823,639645,972550,564116,275630,130872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]