SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504194 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504194 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25700,606246,708064,244665,774799,775129,416136,687998,954650,108457,991557,633683,1003122,610277,316114,758239,289030,437034,859462,764138,196297,761213,191680,124666,698779,480905,811980,987724,929249,798187,1018774,758700,680452,482822,673370,125805,698848,470252,929309,153576,1003382,837865,833885,75764,732847,1012533,257729,924630,74049,652506,536252,982645,565305,629040,10127,425512,683092,23096,262481,669423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]