SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313309 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313309 [ RunTime:0.003333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80180,207070,976480,53716,515698,249390,427496,322401,721968,497946,275932,457120,342450,90229,557293,655055,287945,740692,345333,577263,323528,320221,633275,1004778,455780,659846,1004123,255789,941079,45645,460981,409257,690357,636530,150275,1018408,290996,400321,481191,258951,574971,630880,172114,202971,794493,989782,838565,166526,565457,283791,329283,449238,532633,1000556,180655,765230,61179,207121,105621,776003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.009849s ]