SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514217 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514217 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280664,920260,788197,907139,744872,779397,906255,1019086,415791,629122,749448,873870,545671,933155,742425,644667,193786,786405,923856,479403,487237,418975,544083,695007,1002696,463977,129471,1015745,967290,303134,229436,654463,489083,675076,726730,545722,166526,454166,612373,684032,603290,205747,235118,433487,931521,539171,657036,357988,1029867,928051,603881,897136,565526,593957,645089,488964,854984,158090,760972,706837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000989s ]