SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027310 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027310 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473940,399406,859716,128899,407951,557093,644826,376838,818584,703311,364411,1045493,508482,345825,215950,880496,584380,41063,235721,750117,104098,303022,492725,768768,477133,501906,381691,759131,785521,355611,853953,196245,688168,330999,895202,39813,339273,607221,908122,641492,448388,945609,336661,60767,896456,297851,3096,606718,785086,732193,868412,899389,425985,153601,633100,933165,78190,19962,300149,393076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]