SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141041 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141041 [ RunTime:0.001425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904577,759069,373109,1042935,269912,138368,473272,748704,1041669,711847,538420,27728,615578,600440,603946,87166,367180,98653,701625,755912,582163,205630,138582,250122,222613,209506,198569,654425,656985,969023,415492,672815,250428,700814,209884,836301,729759,619117,489160,667651,454470,119138,621289,204701,1028406,907468,409691,215820,437403,1008863,980282,185848,378618,843740,815289,452308,191839,918444,636529,108500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]