SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814851 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814851 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940135,1044344,408806,923030,1023193,109183,493480,213082,483659,404330,111775,105547,920220,484259,398096,781318,437039,279978,645267,180283,134215,654386,526129,263058,936831,35084,675183,953777,233575,473241,8832,487811,440507,970165,870320,186195,909375,295851,162436,378187,261342,975424,643589,61923,816831,883342,812098,248410,337796,743279,111834,174703,958876,1039923,483323,949535,606777,230969,408232,32411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]