SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026239 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026239 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016333,684274,492487,279999,930740,340466,784450,400250,868367,180449,60147,193688,694901,896947,1018558,515113,923380,16359,134143,483952,153122,522146,157021,220390,456023,1002537,1008852,549047,518483,358578,998205,787232,537657,911693,419611,504169,442623,651712,51746,46893,485261,829800,391176,104700,994187,898635,136917,596153,870592,936967,160616,944503,514763,721356,1012987,215534,114635,192549,966994,683964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]