SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510180 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510180 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791764,879358,973245,317385,624052,32014,250698,1043575,954566,670608,588471,562993,164448,880633,384172,855446,29613,898701,893630,574373,344341,71033,683397,223969,388107,389893,419356,146528,646804,1020701,570745,170665,1028186,148410,944529,310183,264904,603025,677614,515011,565800,1316,891584,818726,302396,875211,548238,595429,330294,1009449,744295,1009853,893705,919951,517901,303784,700185,445132,689504,553127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]