SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450368 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450368 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251924,202534,954427,443731,311925,1007317,112099,374676,93947,1028637,243807,373540,741264,414810,284459,852494,268432,835084,224637,377930,326084,525155,659895,668004,133409,104642,99480,536789,893502,667404,1004348,460649,880729,69102,203500,856552,356014,994162,3329,620163,263934,808753,40699,259573,535397,868754,1000987,785471,190895,901336,471422,737041,35513,452439,37283,231683,812693,458217,761588,753717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]