SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040739 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040739 [ RunTime:0.002974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45831,243061,472321,588199,620991,70915,846734,843712,988476,785236,33676,464858,512574,252522,1018784,83241,708042,832491,18710,570823,409864,525020,877454,359246,860142,87543,593919,483450,810940,963352,935386,983245,546296,569243,726791,400013,568307,775289,567498,597185,350337,744142,891672,1037149,843917,296682,268318,115684,407591,753799,224576,980703,207688,854554,843034,771945,72400,641695,325235,756963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002604s ]