SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527853 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527853 [ RunTime:0.004857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882328,837194,10017,137728,526220,403682,253261,65072,935224,1019219,33720,933632,905915,851167,156561,611307,780819,49428,821482,189318,340513,153714,474908,968436,768180,272140,552007,574389,525132,980811,485336,987541,350375,536744,677420,486902,731340,824118,553080,1044815,1015932,585238,315719,315168,387643,822677,46445,564007,412492,59303,790435,743881,595464,19222,874090,895100,454859,971607,501632,408468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]