SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482680 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482680 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353084,58019,890452,394325,903199,441661,778290,67240,734444,131032,45569,263514,1039279,365730,281444,168823,197646,782808,518268,685746,68371,609900,874996,399416,91183,14534,761205,55553,374038,892314,673467,226911,299266,794879,856908,643643,1003701,292356,663752,961363,51869,272809,787789,1024428,574818,374521,684629,288705,883495,683162,417980,556228,4815,407998,751599,314622,905727,273828,662564,264133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]