SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502533 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502533 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548058,1048673,750593,988382,370316,444286,136001,668627,938707,546192,205660,579591,373255,771213,872681,175133,777306,516113,142460,806646,12905,647419,762174,1010024,637838,255032,204403,107223,627782,561053,376659,92909,1009609,204385,582273,94943,16751,281113,721550,403552,675903,741196,272635,582757,282118,451107,278765,846222,524788,662590,952792,619741,310309,560376,20181,608369,957674,713095,853208,403702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]