SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704180 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704180 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020939,595441,844321,206284,554854,411622,399708,229170,602916,440561,195692,650347,1015815,922897,763315,556690,492479,253868,627032,376314,879826,137701,501301,515654,421782,91307,519434,983036,52856,385833,640648,493811,222699,708393,659573,116374,587234,333533,995020,155058,333515,505128,722690,305649,417301,543766,859348,350645,202001,1035338,719991,671716,147004,134259,670099,529138,512420,124086,839471,844004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]