SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 350209 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 350209 [ RunTime:0.005177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813819,507712,399462,420912,983690,733665,840719,389954,869372,818499,286982,1043465,457442,522973,977182,229957,653089,331955,952182,92479,624244,421213,794525,249947,742720,940763,641439,283933,1017331,863359,93246,956774,415156,802285,505058,292991,373145,765589,186368,231189,1030565,936841,85057,194254,268049,38467,768101,710564,808045,895331,662156,388388,157729,1010591,97386,1026193,545803,487091,1018399,172026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 350209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 350209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]