SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535300 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535300 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950039,787010,74910,647174,145624,260859,733377,357692,992649,761845,963005,217451,835187,17899,96908,181681,874909,652111,889749,83712,722429,790847,691535,651677,550020,522812,213426,922202,309435,169893,92967,653529,325739,641894,649319,209410,373023,605475,198102,425976,630316,18882,697510,607177,198228,849419,125875,973498,6958,13278,1008558,373883,588854,862356,264539,569722,736965,169247,562144,409436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]