SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 132161 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 132161 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664570,925183,492813,557014,648178,632997,287097,464896,487270,1013875,145793,494780,185970,446219,745341,471171,937402,216450,132849,142830,239789,66762,377279,230297,730865,742608,745672,961972,272827,932804,286852,568312,261939,233365,422716,638202,691445,23173,271488,267761,996351,144924,585321,42980,26732,1016656,85811,787189,847050,1002918,703891,676303,673428,313021,777036,406188,1025012,861878,735901,799101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 132161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 132161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]