SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439403 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439403 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014307,787875,842909,454249,499667,372693,246041,68526,854457,1046193,733474,907234,340652,309451,303414,181178,549765,718238,172965,540349,832298,3114,923065,544847,861089,813079,271922,171279,126477,374660,341281,236903,367664,990493,639792,517415,138972,674445,322968,612115,305036,920226,454562,743862,541515,1036771,636732,947161,467068,586465,708144,235051,716331,737887,814480,955943,869004,714494,470112,983298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001487s ]