SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453412 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453412 [ RunTime:0.004450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903739,491218,749584,29440,698334,810495,366603,804026,263602,629537,625692,375818,923998,944126,519291,349291,72072,334758,1002878,355560,371181,148974,482560,901535,914468,631386,195484,573572,510228,539404,333592,577686,680787,244094,629032,401784,933184,339345,1030684,979764,298926,231697,144352,554428,304996,879865,153300,86636,18678,600970,478128,49463,750702,828639,956905,360649,1008795,115415,407738,180225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003464s ]