SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001609s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434684 LIMIT 1 [ RunTime:0.001913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434684 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353778,419071,254642,362200,961988,572110,130490,455704,340593,363388,770564,435590,994491,713102,919152,1037178,665742,660632,750640,568794,581863,700808,56450,370287,972703,730699,571887,70959,368027,647999,608138,126238,188940,36630,711180,230477,791766,78924,568586,357689,271791,159833,556747,191513,31236,458147,215672,809988,129802,130422,114148,467546,990774,641888,412534,333818,470823,684111,951601,185666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002213s ]