SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345522 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345522 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269983,696679,1039072,37754,833576,145046,923158,1005253,477697,57740,798029,168226,100568,719478,462554,998619,987381,479462,195549,190979,212608,1023933,799699,106409,678744,1028309,172470,723382,897672,223789,13554,893835,439480,209825,916123,465062,552153,958476,806415,119658,78116,410287,318352,689637,785761,419441,213062,758419,996635,363291,178090,1964,723525,682001,607215,684299,816366,176055,131091,687792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002541s ]