SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201161 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201161 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801789,245648,313590,271869,586891,68561,822098,97513,553280,52138,925373,491118,327913,839615,753567,827343,772480,316058,564292,697164,149683,804028,11547,355177,338301,228010,225414,933898,506467,596197,473706,358041,829511,199984,677652,476981,483320,312464,545665,744208,1010540,817396,962471,667279,501844,777930,310152,166211,329417,101198,889397,384160,671485,54745,524622,486902,326992,617037,342515,174020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]