SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414437 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414437 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519469,891067,1047648,797291,552153,46486,10117,29170,489198,639343,421462,687282,197463,603479,157771,870280,805076,721982,398213,930090,143630,641082,64792,276549,533780,459990,493791,410213,869738,249299,461603,251249,204036,469235,582621,770179,361326,877225,233680,519291,17822,36663,742602,662077,400903,893551,407915,537788,1035659,719429,220397,241375,46175,608160,879567,517635,267986,569830,938171,127652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]