SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513693 LIMIT 1 [ RunTime:0.000856s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513693 [ RunTime:0.003300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000248,397732,456368,293567,1034909,615619,997541,298544,451393,103812,898275,96676,775552,772360,294836,989129,719890,402057,222082,128063,46446,624216,661808,794712,133936,891522,988196,377070,317866,22871,36943,401775,885843,448457,575158,778809,726366,393130,245374,505712,693782,77509,364179,793500,523866,196014,781314,598143,617557,791075,934076,220993,622011,661183,847113,812280,941672,794693,899823,560315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001054s ]