SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301617 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301617 [ RunTime:0.001430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492314,184125,1039381,678525,699130,378686,445762,1041150,960979,722203,107455,1024453,1000733,976414,525799,343110,911156,473740,519973,144117,331893,980040,1025651,344336,1044039,337210,843612,799887,776934,19735,688962,273232,33045,805062,285448,132848,601515,341932,814943,340189,810711,635467,154549,1039023,815517,822091,124864,502032,191444,619644,729288,33558,116054,196257,547647,320890,18951,938206,235968,373862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]