SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425500 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425500 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362860,133737,150588,11794,205521,813782,36633,830729,227525,826628,666840,300061,98094,695560,233531,907137,648421,499824,1040366,460606,576012,996858,419340,289615,104148,901633,897587,600868,130567,75530,269807,838599,469384,272609,986144,199380,350803,892014,347460,825833,190463,586861,341082,84767,710288,828079,681247,253630,497697,321518,875342,387915,171048,288206,883683,489974,816808,301524,811288,156686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]