SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040540 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040540 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849237,872218,658250,8298,750316,503258,625070,139312,191431,1037319,996961,69664,159368,32754,654240,939459,505927,1004858,1021275,795411,1029526,193796,511563,56728,848001,948499,524883,9462,957528,149758,12035,847873,1046142,83376,465420,304046,1046697,324730,610772,247089,100283,567196,748739,842615,676293,697017,61592,1026151,1044550,843127,972294,417811,495465,158221,286911,306812,505528,194532,175910,123900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]