SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986072 LIMIT 1 [ RunTime:0.000763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986072 [ RunTime:0.006202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202100,431897,577495,969800,362225,1034301,86996,822425,486323,56962,594489,610124,211110,988957,997565,248388,994245,476945,782909,680647,645425,473385,599648,757060,943838,111454,390050,588389,4795,581932,907675,1033198,103233,17768,617245,895846,477174,239864,394110,984504,714493,443287,383041,59503,108710,217530,720465,1023280,864194,841357,130242,284610,320454,790761,817994,724746,7823,118910,714213,718210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]