SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502937 LIMIT 1 [ RunTime:0.001784s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502937 [ RunTime:0.002947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454230,769863,516481,596429,243770,303006,836013,579258,438007,856639,328252,30899,613533,297418,376482,998571,657317,963148,426416,1030305,670867,437205,690659,515861,709014,721465,400035,214911,361997,993420,466481,201048,378195,566406,1018909,789290,277161,837559,158428,447285,231064,238546,660747,521413,101530,446327,285549,426956,967947,621545,334567,673426,547385,86875,135406,694130,108742,145755,70942,200517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502937 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502937 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]