SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509417 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509417 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032280,1039537,122737,365187,694433,477513,430217,163370,89536,542843,1003002,240065,308602,864460,380816,395529,538882,959813,969817,128373,677117,11913,1040002,642628,815509,1002618,271147,341952,703762,722222,465730,490160,8924,981160,702457,52680,367707,177251,573559,318745,868617,441843,316327,503151,587392,98305,770788,128177,800139,51409,438795,300443,225620,359963,694126,482483,622608,592805,181166,317467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]