SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311710 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311710 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255465,883500,703269,710259,727100,841393,404319,179575,984763,910576,421872,426368,936101,960733,834308,665984,515283,677105,488402,712301,234629,109885,184003,585773,63929,44167,512570,634718,2064,683192,238494,209266,910880,1034957,694555,132744,153865,63976,987191,761508,290052,636859,696297,502724,670136,884437,695456,224597,302557,760502,788701,983135,806638,325210,501845,426004,304111,861102,967595,779739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]