SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803981 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803981 [ RunTime:0.002529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425164,305669,901855,594434,999399,167141,915142,1032017,449157,610304,953267,513970,126789,318512,978069,1003696,507958,217071,501345,335111,422513,230734,80182,621360,731618,253058,1008171,54269,836776,911322,4794,870183,965695,115327,500007,544164,414950,53838,125278,910462,625510,207064,244595,979328,910722,470352,747308,275368,533049,683582,870725,237900,666576,778636,543904,228753,919406,448498,525886,247136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]