SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199960 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199960 [ RunTime:0.002581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968286,839108,945839,372064,107326,146671,218802,932632,956504,458162,316581,98436,750040,23223,483871,78167,712907,1042923,926546,111976,260210,895311,695926,456824,904235,688722,859045,942267,596544,543314,834850,523971,814595,246722,336786,1012904,937924,90422,408241,273227,705235,380648,542048,152339,455828,651766,279357,541555,315736,430919,205323,522226,964405,128690,222907,742280,522496,731211,706112,774185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]