SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420571 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420571 [ RunTime:0.002347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570894,190689,6942,815966,598434,38276,919020,99703,78818,183945,1037775,893386,384781,605808,576621,678974,968692,172381,602021,240285,977055,423076,623144,851040,645588,412211,926296,539109,188599,661403,341338,848338,339164,540699,104013,741819,102839,72069,289420,863986,640384,51805,654539,1028495,724303,365910,680960,32138,414323,60207,237443,274954,462177,331807,33111,45072,342736,784359,629636,60783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001140s ]