SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003711s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482483 LIMIT 1 [ RunTime:0.001978s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482483 [ RunTime:0.004321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187104,638800,101702,207187,54432,1016108,577199,517141,30963,540409,884539,621913,252768,190262,970634,887703,28844,383787,732544,524088,147596,929841,537991,845805,651914,791403,643704,184184,764703,322736,867492,15751,828801,338929,402487,362155,928840,812708,104361,379738,975223,974047,672818,308409,1026878,942272,843396,401737,908562,591612,267705,600226,474528,766514,382725,913600,227749,545801,587030,699870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]