SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514816 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514816 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355152,886270,672335,736675,509124,284408,794671,626177,339839,955601,648374,158376,405847,862429,841986,762266,942014,439060,135783,680950,583637,601137,1046791,879625,892692,674989,162534,998515,966479,498687,1000618,598246,1002054,858765,975751,357377,336758,309821,576621,650745,969849,889352,100077,152557,124346,766203,531148,880135,758550,384458,171234,748,826750,693949,131524,435612,751288,934709,788599,786540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]