SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31564 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31564 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829129,969268,449341,214325,1004054,698918,811693,178077,767874,210145,997698,702791,519919,195623,803841,382888,971298,575536,648967,993138,578535,492087,452130,512013,958654,725081,706030,66739,578171,1026167,124201,1002947,346433,15566,748129,265524,188517,522315,66822,366392,262827,49815,352312,12804,76465,756348,1042873,315644,705765,845232,853103,353700,76280,601488,403899,740662,539000,103257,1005718,257048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]