SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039711 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039711 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396373,592326,816916,843517,329616,528187,856302,589269,815856,979862,320589,544703,318934,344184,438061,926660,833740,501500,155255,245902,671412,565803,126779,939869,333939,546853,226068,846657,197990,711051,887627,539686,208016,412541,927192,81021,378212,729181,454739,59604,882296,293312,880852,1013877,389593,1045152,714308,474539,611640,265392,826665,213107,370177,576528,157170,95410,958968,1014373,955511,757002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]