SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421143 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421143 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184958,24078,143728,371901,52421,771339,662912,324325,112328,127219,994530,1044609,946858,645317,822064,80738,110609,792115,610491,190030,926696,60249,683515,289401,382194,852594,384662,242350,824430,647706,365818,873152,324293,581193,475776,375924,760801,1009846,211609,795953,232209,629101,515507,544252,781617,925146,829549,37828,489455,527257,39273,683630,158618,598623,948012,131414,400750,969327,725457,504917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]