SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023311 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023311 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979810,601536,695197,1036018,123224,794917,3998,223558,901821,232928,60485,998570,202535,864027,1027461,716115,701046,383106,738249,476433,995471,1028227,234530,58844,1025777,922091,55119,23427,312396,794690,468254,50028,1017262,49442,948805,228206,821056,1036313,351492,758720,918014,368343,935317,594670,328051,856926,536986,41641,1039230,775594,978912,839098,421064,763832,857883,1022810,643051,59894,620072,183085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]