SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266043 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266043 [ RunTime:0.002540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862064,169394,510409,47213,920978,838262,685427,1007935,335703,16447,718675,843524,520226,834710,645071,122210,753594,600706,922737,462392,76023,65340,962834,325940,249485,213991,1002382,692357,350395,474660,852839,414932,608858,555325,702872,216754,426089,956833,831840,918251,179688,975822,939143,504674,745068,969853,205062,362430,254844,380695,651076,937093,800190,212130,287163,444814,267783,777947,437818,277195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001140s ]