SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038586 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038586 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107172,1019470,434268,1021441,10516,196102,485080,325076,309666,123906,989557,243040,1037035,767206,428228,534696,103558,348172,884072,61832,472317,195338,677464,513895,619348,180430,346386,109757,886934,306486,512306,259446,376258,5625,769600,210500,985853,54711,878927,353411,744368,616650,1033325,917208,26163,1028737,583682,45841,852930,613822,182275,207864,9190,734018,505456,511763,805950,916814,461936,304437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038586 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038586 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]