SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030164 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030164 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997152,121180,685539,200127,747089,218908,486499,932208,271619,537592,475973,95066,466485,215006,622581,699013,686405,322395,68320,178540,376849,56964,607583,192334,297585,234370,914257,772901,407623,1048076,887698,347248,163396,855908,826086,270719,907822,508554,961122,295576,939061,304818,417889,742858,960056,257321,710033,130036,375192,135033,89724,928447,719350,663183,1045505,987501,75159,328301,934661,430747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]