SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514500 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514500 [ RunTime:0.001225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002236,796776,125592,935891,138689,439673,586111,326169,28464,906325,752692,5985,117825,96738,1037714,590358,797819,264290,587889,350155,234250,993078,954197,248365,407604,364137,823317,75873,129494,620880,683072,892284,427135,382483,476279,1043556,272140,1034246,670650,203647,345733,798638,8017,309753,608206,1036065,922044,751111,372116,587764,419519,160768,429970,267603,501753,890107,608461,46788,108391,671885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]