SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541906 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541906 [ RunTime:0.002937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689754,546501,86172,441908,129415,327557,232362,257905,427628,803643,615784,424952,161654,483235,505551,78298,666628,394406,167460,610171,994270,682381,40569,212909,160605,775464,930186,267086,362632,74559,89697,230773,351842,464807,244735,311841,1004399,1010841,899101,1013801,504552,359412,8827,721316,571744,436449,1019287,582319,486963,438989,331202,245040,23823,781461,292161,745812,158735,322246,208518,500805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]