SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478029 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478029 [ RunTime:0.004173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581484,407866,1030525,210140,71283,944371,159913,844879,345527,471937,850141,645695,433796,1025048,281589,221271,204656,692089,485812,457614,806025,990076,802945,534442,800018,913926,990794,374423,579495,762302,52631,495549,727313,728338,124282,736506,798098,304718,151540,210113,244906,858937,130817,1033213,494803,83171,311159,294175,965737,823461,863995,887865,1004960,771908,486602,178126,1035594,495807,654696,581042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]