SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309683 LIMIT 1 [ RunTime:0.006860s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309683 [ RunTime:0.012685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470321,825806,324179,477911,536739,887555,66970,231979,143135,43575,846568,292644,697422,727029,21540,991791,103763,1011602,384080,157832,851221,863514,473032,935996,465183,307654,1005027,246992,358077,18327,927207,360170,122509,206396,710239,795343,122946,990195,385182,411321,393879,533787,689361,740771,246048,445074,173761,635849,659874,493260,446407,452498,936782,685668,130728,485874,288238,381625,399411,446587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.010156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004411s ]