SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318170 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318170 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80511,1029970,368752,402545,1006178,188625,276203,754947,1022938,43955,538858,463354,221540,199981,282101,961919,11919,48554,1018124,920540,185805,189895,295223,555664,360296,741704,349887,940461,569391,207111,322802,405161,493594,894237,935329,370060,915757,332639,971632,924256,194933,309635,325416,1006165,643289,595667,860191,251496,98552,656149,319198,93507,121715,111254,64051,126417,292684,230744,965139,46930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]