SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570091 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570091 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45684,264436,1020762,1041386,413155,334861,469007,154316,891030,410140,197970,12987,639858,910562,326856,963601,667666,734987,636100,37825,12757,27250,480448,783530,910394,460981,377297,870978,709167,1013066,324120,789964,277688,577851,876105,447035,923158,339704,914477,280898,942438,383462,4840,734644,976198,954301,1022072,654575,420528,5985,168625,148441,187333,423214,16271,1019472,133899,251146,2515,223473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001709s ]