SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457879 LIMIT 1 [ RunTime:0.000594s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457879 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514818,406143,1016671,840176,317381,803498,637918,79963,490786,298385,777120,431928,1024041,833916,24522,176548,85251,587961,413322,313380,495339,707377,764770,710480,66674,912095,829970,209238,171925,959227,859481,785580,456483,29577,619487,169465,289262,96007,907775,472757,896609,938004,222492,220743,935754,423080,104857,550764,957894,788895,874558,761783,474094,638788,615026,692822,137353,187154,891559,645715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000789s ]