SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198083 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198083 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82591,27715,405270,852042,153918,279592,579460,503792,522399,240383,170938,165692,846839,611535,904745,883540,998502,462353,55676,84501,296354,131726,466442,993129,662236,547002,852595,741815,140634,680924,14773,479756,243920,47853,906795,667641,772807,756355,340398,67506,332559,110814,972004,567186,813331,305715,840959,984330,255460,751947,117741,626068,490115,92023,325011,317289,657507,273504,40491,160461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000928s ]