SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012400 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012400 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781251,692365,697026,431522,779562,785934,739944,127474,763534,11222,192262,675484,1006270,70768,8608,242963,535937,32338,627701,195115,940310,549827,902698,827050,242947,683889,701325,201678,606132,242949,384813,114606,241561,141715,901374,876227,40033,166127,385321,463175,51588,184442,370876,51811,857251,535510,554192,486792,223787,892402,603745,666550,534627,745326,539769,1013002,142350,474705,1010554,34857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]