SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438613 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438613 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34479,165962,247629,475871,844115,525395,710174,171581,264440,902000,214465,241260,510455,941617,621453,378335,948848,328255,486723,851673,518054,184974,930563,29514,316001,527603,159681,778815,59613,168869,279794,910882,1033151,986579,245643,780212,701643,197604,1018208,678243,93113,768782,169934,754512,43347,1026191,487059,594965,897550,825172,839573,625973,883342,551870,1018630,281363,600220,171574,165544,862650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]