SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022466 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022466 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414113,126148,280048,830993,303209,711271,735340,348225,482901,89986,383200,936695,999800,666022,162445,105117,383633,591669,162129,112977,559344,139995,870021,640250,657652,522064,319310,1007549,505810,288543,68040,3884,653246,247778,14003,264946,905551,812395,606700,105410,258137,102288,978642,66710,1023883,240589,84375,51600,130992,964073,1016080,407441,1027174,654169,8646,418974,781396,980862,314752,754540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022466 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022466 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]